﻿/*
后期部署脚本模板							
--------------------------------------------------------------------------------------
 此文件包含将附加到生成脚本中的 SQL 语句。		
 使用 SQLCMD 语法将文件包含到后期部署脚本中。			
 示例:      :r .\myfile.sql								
 使用 SQLCMD 语法引用后期部署脚本中的变量。		
 示例:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

delete from t_ara_department;
delete from t_ara_person;

--
insert into t_ara_department (id, name) values ('{94C73848-058D-414F-9182-AD804CE58735}', '综合信息研究室');
insert into t_ara_department (id, name) values ('{37C143C5-514F-450D-9BC5-4D14D30EE783}', '基础设施研究室');

--
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{9AA1A3A4-084D-43DC-A766-D87085DACF3C}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'liguoxia_zh@petrochina.com.cn','李国霞',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{C9C7DD3B-7D25-469C-8251-13934CE8B467}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'陈岑','陈岑',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{4B43D57E-9A44-4CDD-B6B4-FF2086DC26BB}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'李天卓','李天卓',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{2D6AA010-701A-4284-B00B-8199A56559BE}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'caoqiong@petrochina.com.cn','曹琼',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E39F987F-61A2-4C51-8D7A-3DB35AF1DC84}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'yushuiqing@petrochina.com.cn','于水情',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{6AC61DEA-A9EE-4253-ABC2-35BC96E3E6FE}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张磊','张磊',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{059AFC9E-C44F-4805-A40B-BC56E2E43C1F}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'jiangyongquan1@petrochina.com.cn','姜永泉',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{536245E0-FB59-4DC9-B0FC-EF91077B5ED5}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'zhengzhongyi@petrochina.com.cn','郑众一',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{54049708-177D-49E0-A4C1-4857BE49009D}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'sundawei628@petrochina.com.cn','孙大为',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{C17670FF-A255-4F2A-941B-051FE1BE6F33}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'chenyiyan2013@petrochina.com.cn','陈一艳',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{BD69E6EB-B850-4504-9C73-A6124D7D8521}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'yunnailing@petrochina.com.cn','运乃玲',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E442F046-2F3E-4954-8DEB-7E65E3A61E8F}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'xiecheng@petrochina.com.cn','谢程',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{B9862EB4-36A2-46B4-BEC5-0155C5C7FC95}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'许大鑫','许大鑫',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{88EA2964-44FB-4B02-B5B2-9ACC2EAA4904}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'马丹','马丹',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{0A48C561-952C-40BE-B12F-4A7E3BCCD9FB}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'周泽飞','周泽飞',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{ABE3B117-CF9A-4F8E-91C1-E24572E306E8}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张汝意','张汝意',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E48C7445-B94C-4791-AD7E-404149106BCA}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'康之念','康之念',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{20292AB3-D209-4D9E-A6EB-7FE078356F29}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'殷晓','殷晓',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{BE3D79BC-51F1-4659-A5C8-18C05815C5F8}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张志强','张志强',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{1065B05C-3DFA-49B1-A840-651E26DF5C0A}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'柴卫星','柴卫星',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{31F7055B-1C3C-4DBB-A221-03138795C29B}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'王洪川','王洪川',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{9F4DB234-EA6A-45AA-9E40-0C1D0A571294}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'金熹龙','金熹龙',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{02B8817B-9615-4970-963F-0F0C4EA1C5E4}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'林永平','林永平',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{119B6835-C5E7-4DBB-8C66-FC3E747D1A3D}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'李岩','李岩',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{1AFC7FD2-CDCF-43EB-A646-9387B564334F}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'杨朔','杨朔',1);

--
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{3E4EF8B0-255A-4084-8BB1-888FC4103C94}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'杨丽春','杨丽春',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{2AECFA62-0792-44A4-AAC1-7BEFE5AFF1AC}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'宁磊','宁磊',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{4A4940A3-7F1C-4A59-BE88-33EF95C89718}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'卢哲','卢哲',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{D6573D99-570B-4AE1-BCDD-CB988E5AD05C}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'曲晓涛','曲晓涛',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E22CE21B-2084-43D2-99F5-6B4B284DFAFA}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'郭长杰','郭长杰',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{0ADC4375-0AF8-4A36-BCC5-B5795A60B273}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'尹兆涛','尹兆涛',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{B9C10114-D413-47FF-9882-C6C9FECBBB79}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'王浩翔','王浩翔',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{56D01DAD-1446-409B-9E1E-056C506E752A}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'李禹宏','李禹宏',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{19EAE48E-E6E4-4335-8F0F-2783BE830075}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张春生','张春生',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{501A73A9-D651-41BE-82A7-3E025899EE67}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'孟超','孟超',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{47F36384-77DA-4B75-A300-0D2CD24DBD8A}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'马楠','马楠',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{CF4421D4-C30D-424E-94B1-8EF1C2044E13}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张洋','张洋',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{A1DCBF3D-D97B-4F3F-8031-67A62A0831A1}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张志强','张志强',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{7F62A3EE-2F34-4601-A419-9AD38DFD807B}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'王奉良','王奉良',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{B2C680FB-940C-43F7-934B-F477E00E41C5}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'曹学伟','曹学伟',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{40829C03-4FC0-4025-8A6F-6C1D6E5B604A}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'尹爱莉','尹爱莉',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{90D9BEE4-C405-4327-BE35-1D7F576C22D6}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'宋美玲','宋美玲',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{1E544CE2-83FA-4988-ABF4-91732182A404}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'王伟超','王伟超',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{AAEC4F0F-99D6-4144-92B1-D388ACD4C8E8}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'刘洋','刘洋',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{5FCC3E29-F06B-4A8A-B76C-685FB8881090}',
	'{94C73848-058D-414F-9182-AD804CE58735}', 
	'张啸','张啸',2);

--
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{BF7A121C-9CED-42E9-BBB5-7EAC1DEBD44F}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'李楠','李楠',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{5E44EE44-9EB7-4C86-BDAE-0AA24A58B30C}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'穆鹏仁','穆鹏仁',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{5E730983-3D71-416E-9D81-E54B5E6D5AA4}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'开和平','开和平',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{84D5C4B5-73D7-4FFD-B81B-0CD19BDE9BBF}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'闫翔宇','闫翔宇',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{2EF9361F-DE6A-4F74-A217-3DF87B6C5DA4}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'石海东','石海东',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{D5F0FBAB-E597-4E97-9E46-E8B6A0D580C1}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'樊强','樊强',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E58D93AF-D022-4579-8D87-2EEBBF571A42}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'许振国','许振国',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{44274573-0796-4AAB-A6CF-3C882D272877}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'李东艳','李东艳',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{DC3C8376-E1DF-4E56-BFC1-84879DD20157}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'林延鹏','林延鹏',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{6B123DA7-3E92-486B-B74E-0728D82A3F2F}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'吕大鹏','吕大鹏',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{90C02AC0-0BAC-470A-B123-FBA084D2D728}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'张蔚','张蔚',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{5B403EAA-427A-41E9-9D63-C99ACBCE877C}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'张洋','张洋',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{62B4A08B-D523-4A95-AFED-408D6E02D711}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'蔡来师','蔡来师',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{DA6975B2-C5CB-4288-89C1-276C366EEECF}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'刘广伟','刘广伟',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{BD479ADC-D075-45BE-9B51-982A8924BD5B}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'刘洋','刘洋',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{CADE3C0F-F425-4C8E-B482-28795820306B}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'王会昌','王会昌',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E19B528C-1C06-4144-9A1B-BB8DB0A7945A}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'张海舰','张海舰',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{F26F7190-E29E-430C-8C3B-BAAE0A5A819B}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'王艳飞','王艳飞',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{8C26D460-19FB-40AF-A10F-1003FDD3F098}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'白金鹏','白金鹏',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{8AFD36E7-739A-4D30-AE4B-582E1B2814FB}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'刘亚会','刘亚会',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{6DE76A72-64F1-404C-AC3C-CCA750C63DE3}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'陈雷','陈雷',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{2CAC0891-4D8B-4798-B6CB-938214DE0BF9}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'龚元军','龚元军',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{C5AC27ED-E793-43B6-8DB7-F85A21C7EC84}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'刘艳红','刘艳红',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{4AD9764F-501E-4E0E-BEBE-140DF08ECAB6}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'张文强','张文强',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{799875DD-5AA9-49D1-851A-995C2AB0B239}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'时连芳','时连芳',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{240FB0EE-74F3-4A24-9F85-6E55C243712C}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'李丛','李丛',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E82846A8-FF5C-455B-B53F-59D131323FE5}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'蒋高杰','蒋高杰',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{8D6FD1B6-985B-40BE-BE1F-32DA6839F0EF}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'姜雪娇','姜雪娇',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{0A5AA739-B081-493B-B4DB-7007D4ED79FD}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'梁春','梁春',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{A5685E5E-F474-4105-A01A-0D4A23912E82}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'赵腾','赵腾',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{CB90B248-3E46-4454-BFDB-2954204B7D1E}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'刘梦蕊','刘梦蕊',1);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{70ACBC3D-A4A5-486E-9E0A-91D6CF7E9A7D}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'蒋爱莲','蒋爱莲',1);
--
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{E4D138CB-D5AC-4F70-A89E-8E7F52572311}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'王峰','王峰',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{970336E6-E022-472C-A5EC-5063D0DE1871}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'王洪旭','王洪旭',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{FE21947F-CFAA-4D43-BB68-8604F4B8EFF9}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'肖登位','肖登位',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{DE056963-4FA8-4D63-8994-85A2C37A31F5}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'罗玲','罗玲',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{0FF9900E-41B3-4CEC-8AC7-D1C00C681B67}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'古超','古超',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{20F6A6C4-6897-4156-83E3-890B04C6240F}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'秦忠连','秦忠连',2);
insert into t_ara_person(Id, DepartmentId, Account, Name,[Type]) values ('{21F052CE-2039-4E53-B9CC-30BCD117550D}',
	'{37C143C5-514F-450D-9BC5-4D14D30EE783}', 
	'赵龙','赵龙',2);


